package com.manage.colligationQuery;

import java.sql.SQLException;

import javax.naming.NamingException;

import com.framework.Dao;
import com.util.DBUtil;

public class ColligationQueryOfTxDao extends Dao {
	
	public ColligationQueryOfTxVo query(ColligationQueryOfTxVo vo){
		String sql = "select id,name,idcardnumber,phonenumber,car,platetype,settle,platenumber,buytime,drivingtype,squadron,bigvillage,village,print from t_household_register "+this.makeWhere(vo);
		try {
			return DBUtil.querySingular(sql, new ColligationQueryOfTxVo());
		} catch (SecurityException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (NamingException e) {
			e.printStackTrace();
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		} catch (NoSuchFieldException e) {
			e.printStackTrace();
		}
		return null;
	}
}
